CREATE TABLE [dbo].[JY_Attachments]
(
[JY_Attachments_ID] [int] NOT NULL,
[JY_Attachments_Path] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Attachments_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Attachments_Add_Time] [datetime] NULL,
[JY_Attachments_Add_User] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Attachments_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Attachments_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_Attachments_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JY_Attachments] ADD CONSTRAINT [PK_JY_Attachments] PRIMARY KEY CLUSTERED  ([JY_Attachments_ID]) ON [PRIMARY]
GO
